LOAD DATA
TRUNCATE 
INTO TABLE cafou_adi_sec_tb
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS 
(
 SEC_01      "TO_NUMBER(SUBSTR(TRIM(BOTH FROM :SEC_01),1,10))"                                         --Idcarrefour      
,ISU_16      "SUBSTR(TRIM(BOTH FROM :ISU_16),1,15)"                                                    --emetteur         
,ISU_27A     "SUBSTR(TRIM(BOTH FROM :ISU_27A),1,15)"                                                   --pays             
,ISU_29A     "SUBSTR(TRIM(BOTH FROM :ISU_29A),1,15)"                                                   --paysactivite     
,ISU_52A     "SUBSTR(TRIM(BOTH FROM :ISU_52A),1,15)"                                                   --autretaux        
,SEC_03      "SUBSTR(TRIM(BOTH FROM :SEC_03),1,15)"                                                    --gardien          
,SEC_09      Date 	"YYYY/MM/DD"                                                                   --datecreationtitre
,SEC_11      "UPPER(SUBSTR(TRIM(BOTH FROM :SEC_11),1,15))"                                                    --actif            
,SEC_16A     "SUBSTR(TRIM(BOTH FROM :SEC_16A),1,15)"                                                   --verifinitie      
,SEC_18A     "SUBSTR(TRIM(BOTH FROM :SEC_18A),1,15)"                                                   --taxe             
,SEC_19      "SUBSTR(TRIM(BOTH FROM :SEC_19),1,15)"                                                    --indicquotation   
,SEC_22      "SUBSTR(TRIM(BOTH FROM :SEC_22),1,15)"                                                    --titre            
,SEC_25      "SUBSTR(TRIM(BOTH FROM :SEC_25),1,15)"                                                    --symboleprix      
,SEC_17B     "SUBSTR(TRIM(BOTH FROM :SEC_17B),1,15)"                                                   --droitvotefr      
,SEC_31      "TO_NUMBER(SUBSTR(TRIM(BOTH FROM :SEC_31),1,10))"                                         --porcomission     
,SEC_42      "TO_NUMBER(SUBSTR(TRIM(BOTH FROM :SEC_42),1,16))"                                         --bloccontrole     
,SEC_46      "ROUND(TRIM(BOTH FROM :SEC_46),12)"                                                       --share            
,SEC_48      "ROUND(TRIM(BOTH FROM :SEC_48),12)"                                                       --droitvote        
,SEC_49      "TO_NUMBER(SUBSTR(TRIM(BOTH FROM :SEC_49),1,10))"                                         --lotmin           
,SEC_50A     "SUBSTR(TRIM(BOTH FROM :SEC_50A),1,15)"                                                   --cash             
,SEC_51A     "SUBSTR(TRIM(BOTH FROM :SEC_51A),1,15)"                                                   --devise           
,SEC_52A     "SUBSTR(TRIM(BOTH FROM :SEC_52A),1,15)"                                                   --articleloi       
,SEC_53A     "SUBSTR(TRIM(BOTH FROM :SEC_53A),1,15)"                                                   --bourseprim       
,SEC_64      "SUBSTR(TRIM(BOTH FROM :SEC_64),1,15)"                                                    --source           
,SEC_P2A     "SUBSTR(TRIM(BOTH FROM :SEC_P2A),1,15)"                                                   --departementprix  
,SEC_P3A     "SUBSTR(TRIM(BOTH FROM :SEC_P3A),1,15)"                                                   --primindex        
,SEC_P4      "SUBSTR(TRIM(BOTH FROM :SEC_P4),1,15)"                                                    --codebourses      
,SEC_P5A     "SUBSTR(TRIM(BOTH FROM :SEC_P5A),1,15)"                                                   --typetitre        
,VAR_25      "SUBSTR(TRIM(BOTH FROM :VAR_25),1,15)"                                                    --typeidtitre      
,VAR_27      "SUBSTR(TRIM(BOTH FROM :VAR_27),1,15)"                                                    --typeemetteur     
,VAR_28      "SUBSTR(TRIM(BOTH FROM :VAR_28),1,15)"                                                    --typerevint       
,VAR_29      "SUBSTR(TRIM(BOTH FROM :VAR_29),1,15)"                                                    --codegics         
,VAR_31      "SUBSTR(TRIM(BOTH FROM :VAR_31),1,15)"                                                    --class            
,VAR_32      "SUBSTR(TRIM(BOTH FROM :VAR_32),1,15)"                                                    --cusipisin        
,VAR_42      "SUBSTR(TRIM(BOTH FROM :VAR_42),1,39)"                                                    --desc1            
,VAR_43      "SUBSTR(TRIM(BOTH FROM :VAR_43),1,39)"                                                    --desc2            
,VAR_44      "SUBSTR(TRIM(BOTH FROM :VAR_44),1,15)"                                                    --province         
,VAR_69      "SUBSTR(TRIM(BOTH FROM :VAR_69),1,15)"                                                    --sourceprix       
,VAR_86      "SUBSTR(TRIM(BOTH FROM :VAR_86),1,15)"                                                    --AutreIndice      
,VAR_87      "SUBSTR(TRIM(BOTH FROM :VAR_87),1,25)"                                                    --AutreSecteur     
,VAR_88      "REPLACE(SUBSTR(TRIM(BOTH FROM :VAR_88),1,25),CHR(13),'')"                                --AutreSS_Secteur  
)                                                                                                      
